Program Issue List

This article provides all the Fields available for each View currently available under the Program Issue List Data Source in Upland Analytics.

The following Views are available when Program Issue List Data Source is selected upon creating a report. Click on any of them to view the available Fields.

Issue Owners
Issue Reported By
Program
Program Issue
Project
User - Issue Created By
User - Issue Modified By
*User Permissions - Program

Note: *The "User Permissions - Program" data view is hidden from report builders by default. See Permission-Based Data Views for more information.

Issue Owners

Field Name	Description	Type
Issue Id	This is the Id of the issue.	A
Owner Id	This is the Id of the owner.	A

 

Issue Reported By

Field Name	Description	Type
Created Date Month Year	The month and year the reporter was created.
Created Date Quarter Year	The financial quarter and year the reporter was created.
Created Date Year	The year the reporter was created.
Email	This is the email address of the reporter.	A
Full Name [First Last]	The reporter's full name, formatted with the first name before the last name.	A
First Name	This is the first name of the reporter.	A
Full Name [Last First]	The reporter's full name, formatted with the last name before the first name.	A
Name [Last First] (URL)	The reporter's full name, formatted with the last name before the first name. This field will link to the reporter's user profile.	A
Last Name	This is the Last name of the reporter.	A
Modified Date Month Year	The month and year the reporter's user profile was last modified.
Modified Date Quarter Year	The financial quarter and year the reporter's user profile was last modified.
Modified Date Year	The year the reporter's user profile was last modified.
Name [First Last] (URL)	The reporter's full name, formatted with the first name before the last name. This field will link to the reporter's user profile.	A
Resource Id	This is the resource Id of the reporter.	A
Status	This is the status of the reporter.	A

 

Program

Field Name	Description	Type
Created By	This is the project's program creator ID.	A
Created Date	The date the Program was created, formatted as mm/dd/yyyy with a timestamp.
Created Date Date	The date the Program was created, formatted as mm/dd/yyyy without a timestamp.
Created Date Month Year	The month and the year that the Program was created.
Created Date Quarter Year	The fiscal quarter and the year that the Program was created.
Created Date Year	The year that the Program was created.
Created Date Week	The week that the Program was created.
Description	This is the program description.	A
Modified By	This is the program modifier.	A
Modified Date	The date the Program was last modified, formatted as mm/dd/yyyy with a timestamp.
Modified Date Date	The date the Program was last modified, formatted as mm/dd/yyyy without a timestamp.
Modified Date Month Year	The month and the year that the Program was last modified.
Modified Date Quarter Year	The fiscal quarter and the year that the Program was last modified.
Modified Date Year	The year that the Program was last modified.
Modified Date Week	The week that the Program was last modified.
Name (Text)	This is the program name.	A
Name (URL)	This is the URL link to the program.	A
Number	This is the program number.	#
Organization Owner	This is the organization owner.	A
Owner	This is the program owner.	A
Portfolio	This is the name of the portfolio associated to the program.	A
Program Id	This is the Id of the program.	A
Program Last Status Update	The date (mm/dd/yyyy) and time the Program's Status Update was last modified. This only refers to the Status Update, not the Status or any Health Indicators.
Program Last Status Update Week	The week the Program's Status Update was last modified. This only refers to the Status Update, not the Status or any Health Indicators.
Status	This is the status of the program.	A
Program Status Update	The Program's current Status Update (not to be confused with Status).	A
Status Type	This is the status type of the program.	A
Status Type Id	This is the status type Id of the program.	A

 

Program Issue

Field Name	Description	Type
Action Required	This is the action required on the program issue.	A
Actual Resolution Date	This is the actual resolution date.
Created By	This is the issue creator ID	A
Created Date	This is the issue creation date.
Date Reported	This is the date the issue is reported.	A
Description	This is the description of the issue.	A
External Id	This is the external id of the issue.	A
Impact	This is the impact of the issue.	A
Impact Description	This is the issue impact description.	A
Issue Id	This is the issue id.	A
Modified By	This is the issue modifier.	A
Modified Date	This is the issue modification date.
Planned Resolution Date	This is the issue planned resolution date.
Program Id	This is the Id of the program.	A
Program Name (URL)	This is the URL link to the program issue.	A
Program Status Type Id	This is the program status type Id.	A
Project Id	This is the Id of the project.	A
Project Name (URL)	This is the URL link to the project issue.	A
Project Status Type Id	This is the project status type Id.	A
Reported By	This is the Issue reporter.	A
Severity	This is the issue severity.	A
Status	This is the issue status.	A
Status Type	This is the issue status type.	A
Status Type Id	This is the issue status type Id.	A
Status Update	This is the issue status update.	A
Subject (Text)	This is the issue subject.	A
Subject (URL)	This is the URL link to the subject issue.	A
Type	This is the issue type.	A

 

Project

Field Name	Description	Type
Business Priority	This is the project business priority.	A
Category	This is the project category.	A
Category Sort Order	This is the project category sort order.	A
Created By	Project creator ID.	A
Created Date	The date the Project was created, formatted as mm/dd/yyyy with a timestamp.
Created Date Date	The date the Project was created, formatted as mm/dd/yyyy without a timestamp.
Created Date Month Year	The month and the year the Project was created.
Created Date Quarter Year	The fiscal quarter and the year the Project was created.
Created Date Year	The year the Project was created.
Created Date Week	The week the Project was created.
Description	This is the project description.	A
Last Status Update	This is the date and time of the project's last status update.
Modified By	This is the project modifier.	A
Modified Date	The date the Project was last modified, formatted as mm/dd/yyyy with a timestamp.
Modified Date Date	The date the Project was last modified, formatted as mm/dd/yyyy without a timestamp.
Modified Date Month Year	The month and the year the Project was last modified.
Modified Date Quarter Year	The fiscal quarter and the year the Project was last modified.
Modified Date Year	The year the Project was last modified.
Modified Date Week	The week the Project was last modified.
Name (Text)	This is the project name.	A
Name (URL)	This is the project name. It links directly to the project summary page.	A
Number	This is the project number.	A
Operations	This is the project operation.	A
Organization Owner	This is the project organization owner.	A
Owner Id	This is the Id of the owner.	A
Portfolio	This is the name of the portfolio associated to the project.	A
Priority	This is the project priority.	A
Priority Sort Order	This is the project priority sort order.	A
Program	This is the name of the program.	A
Project Id	This is the ID number of the project.	A
Project Status Id	This is the ID number of the project's current status.
Status	This is the current project status.
Status Id	This is the ID number of the project's current status.	A
Status Sort Order	This is the where the project's current status is listed in the status sort order.	A
Status Type	This is the project status type.	A
Status Type Id	This is the ID number of the project's status type.	A
Status Update	This is the project's most recent status update. Note that this could take up a lot of space in the report.	A
Type	This is the project's type.	A

 

User - Issue Created By

Field Name	Description	Type
Account Type	This is the creator account type.	A
Email	This is the email address of the creator.	A
Full Name [First Last]	The creator's full name, formatted with the first name before the last name.	A
First Name	This is the creator first name.	A
Is Active	This defines whether the creator is active.	A
Full Name [Last First]	The creator's full name, formatted with the last name before the first name.	A
Name [Last First ] (URL)	The creator's full name, formatted with the last name before the first name. This field will link to the creator's user profile.	A
Last Name	This is the creator last name.	A
Login	This is the name of the logged in creator.	A
Name [First Last] (URL)	The creator's full name, formatted with the first name before the last name. This field will link to the creator's user profile.	A
User Id	This is the Id of the user.	A

 

User - Issue Modified By

Field Name	Description	Type
Account Type	This is the modifier account type.	A
Email	This is the email address of the modifier.	A
Full Name [First Last]	The modifier's full name, formatted with the first name before the last name.	A
First Name	This is the modifier first name.	A
Is Active	This defines whether the modifier is active.	A
Full Name [Last First]	The modifier's full name, formatted with the last name before the first name.	A
Name [Last First ] (URL)	The creator's full name, formatted with the last name before the first name. This field will link to the modifier's user profile.	A
Last Name	This is the modifier last name.	A
Login	This is the name of the logged in issue modifier.	A
Name [First Last] (URL)	The modifier's full name, formatted with the first name before the last name. This field will link to the modifier's user profile.	A
User Id	This is the Id of the user.	A

 

User Permissions - Program

Note: The "User Permissions - Program" data view is hidden from report builders by default. See Permission-Based Data Views for more information.

Field Name	Description	Type
User Account Type	This is the report viewer's account type.	A
User Chat Id	This is the chat ID of the report viewer.	A
User Created By	This is the creator of the report viewer.	A
User Created Date	This is the date the report viewer's profile was created.	A
User Created Date Month Year	This is the month and the year the report viewer's profile was created	A
User Created Date Quarter Year	This is the annual quarter and year the report viewer's profile was created.	A
User Created Date Year	This is the year the report viewer's profile was created.	A
User Email	This is the email address of the report viewer.	A
User Employee Id	This is the employee ID of the report viewer.	A
User Ext	This is the phone ext. of the report viewer.	A
User Fax	This is the fax number of the report viewer.	A
User First Last Name	The full name of the report viewer, formatted with the first name before the last name.	A
User First Name	This is the first name of the report viewer.	A
User Handle	This is the Eclipse PPM handle of the report viewer.	A
User Id	This is the ID of the report viewer.	A
User Initials	These are the initials of the report viewer.	A
User Is Active	This indicates whether or not the report viewer is an active user.	A
User Last First Name	The full name of the report viewer, formatted with the last name before the first name.	A
User Last First URL	The full name of the report viewer, formatted with the last name before the first name. The field will link to the report viewer's user profile.	A
User Last Name	This is the last name of the report viewer.	A
User Login	This is the login name of the report viewer.	A
User Modified By	This indicates who last modified the report viewer.	A
User Modified Date	This is the date the report viewer was last modified.
User Modified Date Month Year	This is the month and the year that the report viewer was last modified.
User Modified Date Quarter Year	This is the annual quarter and the year that the report viewer was last modified.
User Modified Date Year	This is the year that the report viewer was last modified.
User Phone	This is the phone number of the report viewer.	A
User URL	The name of the report viewer, formatted with the first name before the last name. The field will link to the report viewer's user profile.	A